package com.coupons.business.partner.dao;

import java.util.List;

import com.coupons.business.common.exception.BaseCouponsAppException;
import com.coupons.business.common.vo.Partner;

public interface IPartnerDAO 
{
	public void createPartner(Partner objaPartner) throws BaseCouponsAppException;
	public void updatePartner (Partner objaPartner) throws BaseCouponsAppException;
	public Partner getPartner(int partnerId) throws BaseCouponsAppException;
	public List<Partner> getAllPartners()throws BaseCouponsAppException ;
	
	public String PARTNER_INSERT_STATEMENT = "INSERT INTO PARTNER(PARTNER_ID,PARTNER_NAME,DESCRIPTION," +
											"STATUS,LCSN_END_DT,LAST_UPDT_USER,CRTN_DT,LAST_UPDT_DT) VALUES(?,?,?,?,?,?,SYSDATE,SYSDATE)";
	public String PARTNER_UPDATE_STATEMENT = "UPDATE PARTNER SET PARTNER_NAME = ?, DESCRIPTION = ?, STATUS=?, LCSN_END_DT=? WHERE PARTNER_ID = ?";
	public String SEQUENCE_NAME="PARTNER_SQ";
	public String GET_ALL_PARTNERS_STATEMENT = "SELECT * FROM PARTNER";
	public String GET_PARTNER_STATEMENT = "SELECT * FROM PARTNER where PARTNER_ID = ?";
}
